{
  "statement":"SELECT tbl_mock_001.mock_025, min(tbl_mock_001.mock_014) AS mock_043, max(tbl_mock_001.mock_014) AS mock_044\nFROM db_mock_000.tbl_mock_001\nWHERE tbl_mock_001.mock_013 BETWEEN '2024-01-29 15:12:23' AND '2024-01-31 15:12:23'\nGROUP BY tbl_mock_001.mock_025",
  "table_meta":{
    "db_mock_000.tbl_mock_001":"CREATE TABLE db_mock_000.tbl_mock_001 (\nmock_020 int(11) ,\nmock_013 datetime ,\nmock_025 varchar(32) ,\nid bigint(20) ,\nmock_022 bigint(20) ,\nmock_012 bigint(20) ,\nmock_014 bigint(20) ,\nmock_028 datetime ,\nmock_029 bigint(20) ,\nmock_006 int(11) ,\nmock_031 varchar(32) ,\nmock_032 smallint(6) ,\nmock_036 tinyint(4) ,\nmock_035 float ,\nmock_004 float ,\nmock_017 double ,\nmock_015 double ,\nmock_016 float ,\nmock_018 float ,\nmock_041 smallint(6) ,\nmock_040 varchar(32) ,\nmock_038 varchar(32) ,\nmock_009 int(11) ,\nmock_010 float ,\nmock_011 int(11) ,\nmock_019 int(11) ,\nmock_023 smallint(6) ,\nmock_026 tinyint(4) ,\nmock_021 varchar(32) ,\nmock_030 tinyint(4) ,\nmock_007 bigint(20) ,\nmock_005 double ,\nmock_027 double ,\nmock_024 datetime ,\nmock_008 tinyint(4) ,\nmock_033 boolean ,\nmock_037 tinyint(4) ,\nmock_039 varchar(32) ,\nmock_003 varchar(1024) ,\nmock_002 smallint(6) ,\nmock_034 varchar(255) \n) ENGINE= OLAP \nDUPLICATE KEY(mock_020, mock_013, mock_025)\nPARTITION BY RANGE(mock_013)\n(PARTITION p20240130 VALUES [(\"2024-01-30 00:00:00\"), (\"2024-01-31 00:00:00\")),\nPARTITION p20240131 VALUES [(\"2024-01-31 00:00:00\"), (\"2024-02-01 00:00:00\")),\nPARTITION p20240201 VALUES [(\"2024-02-01 00:00:00\"), (\"2024-02-02 00:00:00\")),\nPARTITION p20240202 VALUES [(\"2024-02-02 00:00:00\"), (\"2024-02-03 00:00:00\")),\nPARTITION p20240203 VALUES [(\"2024-02-03 00:00:00\"), (\"2024-02-04 00:00:00\")),\nPARTITION p20240204 VALUES [(\"2024-02-04 00:00:00\"), (\"2024-02-05 00:00:00\")),\nPARTITION p20240205 VALUES [(\"2024-02-05 00:00:00\"), (\"2024-02-06 00:00:00\")),\nPARTITION p20240206 VALUES [(\"2024-02-06 00:00:00\"), (\"2024-02-07 00:00:00\")))\nDISTRIBUTED BY HASH(mock_020)\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"dynamic_partition.enable\" = \"true\",\n\"dynamic_partition.time_unit\" = \"DAY\",\n\"dynamic_partition.time_zone\" = \"Asia/Shanghai\",\n\"dynamic_partition.start\" = \"-365\",\n\"dynamic_partition.end\" = \"7\",\n\"dynamic_partition.prefix\" = \"p\",\n\"dynamic_partition.history_partition_num\" = \"0\"\n);"
  },
  "table_row_count":{
    "db_mock_000.tbl_mock_001":{
      "tbl_mock_042":2
    }
  },
  "column_statistics":{
    "db_mock_000.tbl_mock_001":{
      "mock_025":"[-Infinity, Infinity, 0.0, 9.0, 1.0] ESTIMATE",
      "mock_014":"[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE",
      "mock_013":"[1.7065872E9, 1.7065872E9, 0.0, 8.0, 1.0] ESTIMATE"
    }
  },
  "explain_info":"PLAN FRAGMENT 0(F02)\n  Output Exprs:3: mock_025 | 42: min | 43: max\n  Input Partition: UNPARTITIONED\n  RESULT SINK\n\n  6:EXCHANGE\n     cardinality: 1\n\nPLAN FRAGMENT 1(F01)\n\n  Input Partition: HASH_PARTITIONED: 44: mock_025\n  OutPut Partition: UNPARTITIONED\n  OutPut Exchange id: 06\n\n  5:Decode\n  |  <dict id 44> : <string id 3>\n  |  cardinality: 1\n  |  column statistics: \n  |  * mock_025-->[-Infinity, Infinity, 0.0, 9.0, 1.0] ESTIMATE\n  |  * min-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  * max-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  \n  4:AGGREGATE (merge finalize)\n  |  aggregate: min[([42: min, BIGINT, true]); args: BIGINT; result: BIGINT; args nullable: true; result nullable: true], max[([43: max, BIGINT, true]); args: BIGINT; result: BIGINT; args nullable: true; result nullable: true]\n  |  group by: [44: mock_025, INT, true]\n  |  cardinality: 1\n  |  column statistics: \n  |  * mock_025-->[-Infinity, Infinity, 0.0, 9.0, 1.0] ESTIMATE\n  |  * min-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  * max-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  \n  3:EXCHANGE\n     distribution type: SHUFFLE\n     partition exprs: [44: mock_025, INT, true]\n     cardinality: 1\n\nPLAN FRAGMENT 2(F00)\n\n  Input Partition: RANDOM\n  OutPut Partition: HASH_PARTITIONED: 44: mock_025\n  OutPut Exchange id: 03\n\n  2:AGGREGATE (update serialize)\n  |  STREAMING\n  |  aggregate: min[([7: mock_014, BIGINT, true]); args: BIGINT; result: BIGINT; args nullable: true; result nullable: true], max[([7: mock_014, BIGINT, true]); args: BIGINT; result: BIGINT; args nullable: true; result nullable: true]\n  |  group by: [44: mock_025, INT, true]\n  |  cardinality: 1\n  |  column statistics: \n  |  * mock_025-->[-Infinity, Infinity, 0.0, 9.0, 1.0] ESTIMATE\n  |  * min-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  * max-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  \n  1:Project\n  |  output columns:\n  |  7 <-> [7: mock_014, BIGINT, true]\n  |  44 <-> [44: mock_025, INT, true]\n  |  cardinality: 2\n  |  column statistics: \n  |  * mock_014-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n  |  \n  0:OlapScanNode\n     table: mock_001, rollup: mv_dwd_extended_ais_trajectory\n     preAggregation: on\n     dict_col=mock_025\n     partitionsRatio=1/8, tabletsRatio=2/2\n     tabletList=347150,347152\n     actualRows=2, avgRowSize=25.0\n     cardinality: 2\n     column statistics: \n     * mock_013-->[1.7065872E9, 1.7065872E9, 0.0, 8.0, 1.0] ESTIMATE\n     * mock_025-->[-Infinity, Infinity, 0.0, 9.0, 1.0] ESTIMATE\n     * mock_014-->[1.641024E12, 1.641024E12, 0.0, 8.0, 1.0] ESTIMATE\n",
  "session_variables":"{\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"enable_hive_metadata_cache_with_insert\":false,\"hive_temp_staging_dir\":\"/tmp/starrocks\",\"cbo_cte_reuse_rate_v2\":1.15,\"spill_rand_ratio\":0.1,\"character_set_results\":\"utf8\",\"enable_count_star_optimization\":true,\"enable_iceberg_column_statistics\":false,\"thrift_plan_protocol\":\"binary\",\"enable_plan_serialize_concurrently\":true,\"global_runtime_filter_build_min_size\":131072,\"enable_iceberg_identity_column_optimize\":true,\"enable_view_based_mv_rewrite\":false,\"query_excluding_mv_names\":\"\",\"enable_rewrite_simple_agg_to_meta_scan\":false,\"enable_adaptive_sink_dop\":true,\"consistent_hash_virtual_number\":256,\"enable_profile\":false,\"load_mem_limit\":0,\"cbo_eq_base_type\":\"varchar\",\"enable_materialized_view_for_insert\":false,\"large_decimal_underlying_type\":\"panic\",\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"disable_function_fold_constants\":false,\"enable_query_queue\":true,\"select_ratio_threshold\":0.15,\"enable_connector_sink_global_shuffle\":true,\"query_delivery_timeout\":300,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"follower_query_forward_mode\":\"\",\"cbo_use_lock_db\":false,\"new_planner_agg_stage\":0,\"enable_strict_order_by\":true,\"hash_join_interpolate_passthrough\":false,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"enable_rewrite_bitmap_union_to_bitamp_agg\":true,\"enable_array_distinct_after_agg_opt\":true,\"resource_group\":\"\",\"enable_materialized_view_plan_cache\":true,\"spill_operator_max_bytes\":1048576000,\"cbo_max_reorder_node_use_dp\":10,\"enable_hive_column_stats\":true,\"enable_async_profile\":true,\"enable_groupby_use_output_alias\":false,\"global_runtime_filter_wait_timeout\":20,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"cross_join_cost_penalty\":1000000,\"query_cache_agg_cardinality_limit\":5000000,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"cbo_push_down_topn_limit\":1000,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"materialized_view_rewrite_mode\":\"DEFAULT\",\"enable_read_iceberg_puffin_ndv\":true,\"enable_write_hive_external_table\":false,\"enable_simplify_case_when\":true,\"runtime_join_filter_push_down_limit\":1024000,\"trace_log_mode\":\"command\",\"enable_scan_datacache\":false,\"enable_jit\":true,\"big_query_log_cpu_second_threshold\":480,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"enable_short_circuit\":false,\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"prefer_cte_rewrite\":false,\"optimizer_materialized_view_timelimit\":1000,\"hdfs_backend_selector_scan_range_shuffle\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"hive_partition_stats_sample_size\":3000,\"enable_mv_planner\":false,\"enable_collect_table_level_scan_stats\":true,\"enable_populate_datacache\":true,\"query_debug_options\":\"\",\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"spill_encode_level\":7,\"enable_query_dump\":false,\"global_runtime_filter_build_max_size\":67108864,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"max_parallel_scan_instance_num\":-1,\"enable_dynamic_prune_scan_range\":true,\"query_cache_entry_max_rows\":409600,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_materialized_view_rewrite_partition_compensate\":true,\"enable_exchange_pass_through\":true,\"runtime_profile_report_interval\":10,\"query_cache_entry_max_bytes\":4194304,\"enable_partition_column_value_only_optimization\":true,\"array_low_cardinality_optimize\":true,\"interleaving_group_size\":10,\"enable_exchange_perf\":false,\"enable_prepare_stmt\":true,\"workgroup_id\":0,\"enable_pipeline_level_multi_partitioned_rf\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"spill_enable_direct_io\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"cbo_decimal_cast_string_strict\":true,\"enable_hyperscan_vec\":true,\"cbo_enable_predicate_subfield_path\":true,\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"spill_mode\":\"auto\",\"enable_split_scan_predicate_with_date\":false,\"enable_query_debug_trace\":false,\"cbo_materialized_view_rewrite_related_mvs_limit\":64,\"enable_show_all_variables\":false,\"full_sort_max_buffered_bytes\":16777216,\"wait_timeout\":28800,\"max_buckets_per_be_to_use_balancer_assignment\":6,\"enable_query_tablet_affinity\":false,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"global_runtime_filter_rpc_http_min_size\":67108864,\"cbo_materialized_view_rewrite_rule_output_limit\":3,\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":30000,\"enable_outer_join_reorder\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"enable_agg_spill_preaggregation\":true,\"cbo_enable_greedy_join_reorder\":true,\"range_pruner_max_predicate\":100,\"enable_rbo_table_prune\":false,\"spillable_operator_mask\":-1,\"rpc_http_min_size\":2147482624,\"low_cardinality_optimize_v2\":true,\"enable_file_metacache\":true,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_cbo_table_prune\":false,\"enable_parallel_merge\":true,\"cbo_materialized_view_rewrite_candidate_limit\":12,\"cbo_derive_join_is_null_predicate\":true,\"nested_mv_rewrite_max_level\":3,\"big_query_profile_threshold\":\"0s\",\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"spill_revocable_max_bytes\":0,\"hash_join_push_down_right_table\":true,\"pipeline_sink_dop\":0,\"broadcast_row_limit\":15000000,\"enable_prune_iceberg_manifest\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"global_runtime_filter_rpc_timeout\":400,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"full_sort_max_buffered_rows\":1024000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"cbo_max_reorder_node\":50,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"enable_sync_materialized_view_rewrite\":true,\"prefer_compute_node\":false,\"enable_strict_type\":false,\"enable_table_prune_on_update\":false,\"group_concat_max_len\":1024,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"cbo_prune_json_subfield\":false,\"enable_prune_complex_types_in_unnest\":true,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"enable_per_bucket_optimize\":true,\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"enable_subfield_no_copy\":true,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"connector_sink_compression_codec\":\"uncompressed\",\"storage_engine\":\"olap\",\"spill_operator_min_bytes\":52428800,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"materialized_view_join_same_table_permutation_limit\":5,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"enable_spill\":false,\"enable_materialized_view_rewrite_greedy_mode\":false,\"pipeline_dop\":0,\"single_node_exec_plan\":false,\"full_sort_late_materialization_v2\":true,\"join_implementation_mode_v2\":\"auto\",\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"hdfs_backend_selector_hash_algorithm\":\"consistent\",\"enable_expr_prune_partition\":true,\"enable_topn_runtime_filter\":true,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"skew_join_rand_range\":1000,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_predicate_reorder\":false,\"enable_query_cache\":false,\"transaction_read_only\":\"OFF\",\"max_allowed_packet\":33554432,\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"audit_execute_stmt\":false,\"cbo_derive_range_join_predicate\":false,\"allow_default_partition\":false,\"paimon_force_jni_reader\":false,\"enable_pipeline_level_shuffle\":true}",
  "be_number":1,
  "be_core_stat":{
    "numOfHardwareCoresPerBe":"{\"10004\":104}",
    "cachedAvgNumOfHardwareCores":104
  },
  "exception":[

  ],
  "version":"UNKNOWN",
  "commit_version":"UNKNOWN"
}